Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RetailStoreID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | ItemSalesSummary(LE_SMY_ITM_SLS) |
ReportingPeriodID (FK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ItemSalesSummary(LE_SMY_ITM_SLS) |
PromotionalOfferID (FK)(PK) | The unique identifier for a promotion. | ID_PRM_OFR | Identity | integer | PromotionalOffer(CO_PRM) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |
PromotionalInitiativeID (FK)(PK) | A token ID for a retailer's PromotionInitiative instance. | ID_PRML_INITV | Identity | integer | PromotionalOffer(CO_PRM) |
ItemID (FK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | ItemSalesSummary(LE_SMY_ITM_SLS) |